package jpa.entitys.synchro.staging;

import java.io.Serializable;
import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;


/**
 * The persistent class for the SD_CUSTOMER_OUTB1 database table.
 * 
 */
@Entity
@Table(name="SD_CUSTOMER_OUTB1")
@NamedQueries({
    @NamedQuery(name = "SdCustomerOutb1.findAll", query = " SELECT c FROM SdCustomerOutb1 c order by c.promisStagingId desc"),
    @NamedQuery(name = "SdCustomerOutb1.findById", query = " SELECT c FROM SdCustomerOutb1 c WHERE c.promisStagingId = :Id "),
    @NamedQuery(name = "SdCustomerOutb1.findByInstanceNo", query = " SELECT c FROM SdCustomerOutb1 c WHERE c.instanceNo = :instanceNo And c.issync = 'N' order by c.customerCode,c.billingAddressCode,c.promisStagingId asc"),
    @NamedQuery(name = "SdCustomerOutb1.findByInstanceNo1", query = " SELECT c FROM SdCustomerOutb1 c WHERE c.instanceNo = :instanceNo And c.customerCode = :customerCode order by c.promisStagingId asc"),
    @NamedQuery(name = "SdCustomerOutb1.findAllIsSync", query = " SELECT c FROM SdCustomerOutb1 c WHERE c.issync = :issync order by c.instanceNo asc"),
    @NamedQuery(name = "SdCustomerOutb1.findStatus", query = " SELECT c FROM SdCustomerOutb1 c WHERE c.status = :status And c.issync = :issync order by c.instanceNo asc"),
    @NamedQuery(name = "SdCustomerOutb1.findByCustomerCode", query = " SELECT c FROM SdCustomerOutb1 c WHERE c.customerCode = :customerCode And c.status = :status And c.issync = :issync order by c.instanceNo asc"),
    @NamedQuery(name = "SdCustomerOutb1.findByCustomerCode1", query = " SELECT c FROM SdCustomerOutb1 c WHERE c.customerCode = :customerCode And c.status = :status order by c.instanceNo asc"),
    @NamedQuery(name = "SdCustomerOutb1.findByCustomerCode2", query = " SELECT c FROM SdCustomerOutb1 c WHERE c.customerCode = :customerCode order by c.instanceNo asc"),
    @NamedQuery(name = "SdCustomerOutb1.findByCustomerCode3", query = " SELECT c FROM SdCustomerOutb1 c WHERE c.customerCode = :customerCode And c.instanceNo = :instanceNo order by c.promisStagingId asc")
    })
public class SdCustomerOutb1 extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID", unique=true, nullable=false, length=100)
	private String promisStagingId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ACTION_HANDLER", length=20)
	private String actionHandler;

	@Column(name="ADDR_FLAG", length=1)
	private String addrFlag;

	@Column(name="BILLING_ADDRESS", length=500)
	private String billingAddress;

	@Column(name="BILLING_ADDRESS_CODE", length=100)
	private String billingAddressCode;

	@Column(length=200)
	private String building;

	@Column(length=200)
	private String city;

	@Column(name="COUNTRY_CODE", length=100)
	private String countryCode;

	@Column(name="CREATED_BY", length=30)
	private String createdBy;

	@Column(name="CREATED_ON", length=20)
	private String createdOn;

	@Column(length=10)
	private String currency;

	@Column(name="CUSTOMER_CODE", length=30)
	private String customerCode;

	@Column(name="CUSTOMER_NAME", length=300)
	private String customerName;

	@Column(name="DATE_OF_BIRTH", length=10)
	private String dateOfBirth;

	@Column(length=200)
	private String district;

	@Column(name="E_MAIL", length=300)
	private String eMail;

	@Column(name="EXT_NUMBER", length=200)
	private String extNumber;

	@Column(name="EXT_REF_KEY", length=100)
	private String extRefKey;

	@Column(name="EXT_REF_NO", length=100)
	private String extRefNo;

	@Column(name="FAX_EXTENS", length=200)
	private String faxExtens;

	@Column(name="FAX_NUMBER", length=300)
	private String faxNumber;

	@Column(name="\"FLOOR\"", length=200)
	private String floor;

	@Column(name="ID_NO", length=100)
	private String idNo;

	@Column(name="INSTANCE_NO", length=100)
	private String instanceNo;

	@Column(length=1)
	private String isactive;

	@Column(length=1)
	private String issync;

	@Column(length=300)
	private String mobile;

	@Column(name="MSG_ACT_RESULT", length=3700)
	private String msgActResult;

	@Column(name="MSG_ALT_DESC", length=3700)
	private String msgAltDesc;

	@Column(name="MSG_CODE", length=1500)
	private String msgCode;

	@Column(name="MSG_DESC", length=3700)
	private String msgDesc;

	@Column(name="OFFICE_ADDRESS_TEXT", length=3000)
	private String officeAddressText;

	@Column(name="PHONE_NUMBER", length=300)
	private String phoneNumber;

	@Column(name="ROOM_NO", length=200)
	private String roomNo;

	@Column(name="SYNC_CREATEDBY", length=100)
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY", length=100)
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TAX_ID", length=30)
	private String taxId;

	@Column(name="UPDATED_BY", length=30)
	private String updatedBy;

	@Column(name="UPDATED_ON", length=20)
	private String updatedOn;

	@Column(name="ZIP_CODE", length=200)
	private String zipCode;
	
	@Column(name="STATUS", length=200)
	private String status;
	
	@Column(name="PROMIS_ADDRESS_FLAG", length=200)
	private String promisAddressFlag;
	
	@Column(name="BS_TYPE_CODE", length=100)
	private String bsTypeCode;

	@Column(name="REF_SYNC_PK_ID", length=100)
	private String refSyncPkId;	
	
	@Column(name="INTERFACE_NO", length=100)
	private String interfaceNo;	
	
    /**
	 * @return the interfaceNo
	 */
	public String getInterfaceNo() {
		return interfaceNo;
	}

	/**
	 * @param interfaceNo the interfaceNo to set
	 */
	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}
	
	/**
	 * @return the refSyncPkId
	 */
	public String getRefSyncPkId() {
		return refSyncPkId;
	}

	/**
	 * @param refSyncPkId the refSyncPkId to set
	 */
	public void setRefSyncPkId(String refSyncPkId) {
		this.refSyncPkId = refSyncPkId;
	}
	
    /**
	 * @return the bsTypeCode
	 */
	public String getBsTypeCode() {
		return bsTypeCode;
	}

	/**
	 * @param bsTypeCode the bsTypeCode to set
	 */
	public void setBsTypeCode(String bsTypeCode) {
		this.bsTypeCode = bsTypeCode;
	}

	/**
	 * @return the promisAddressFlag
	 */
	public String getPromisAddressFlag() {
		return promisAddressFlag;
	}

	/**
	 * @param promisAddressFlag the promisAddressFlag to set
	 */
	public void setPromisAddressFlag(String promisAddressFlag) {
		this.promisAddressFlag = promisAddressFlag;
	}

	/**
	 * @return the status
	 */
	public String getStatus() {
		return status;
	}

	/**
	 * @param status the status to set
	 */
	public void setStatus(String status) {
		this.status = status;
	}

	public SdCustomerOutb1() {
    }

	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
	}

	public String getActionHandler() {
		return this.actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getAddrFlag() {
		return this.addrFlag;
	}

	public void setAddrFlag(String addrFlag) {
		this.addrFlag = addrFlag;
	}

	public String getBillingAddress() {
		return this.billingAddress;
	}

	public void setBillingAddress(String billingAddress) {
		this.billingAddress = billingAddress;
	}

	public String getBillingAddressCode() {
		return this.billingAddressCode;
	}

	public void setBillingAddressCode(String billingAddressCode) {
		this.billingAddressCode = billingAddressCode;
	}

	public String getBuilding() {
		return this.building;
	}

	public void setBuilding(String building) {
		this.building = building;
	}

	public String getCity() {
		return this.city;
	}

	public void setCity(String city) {
		this.city = city;
	}

	public String getCountryCode() {
		return this.countryCode;
	}

	public void setCountryCode(String countryCode) {
		this.countryCode = countryCode;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String currency) {
		this.currency = currency;
	}

	public String getCustomerCode() {
		return this.customerCode;
	}

	public void setCustomerCode(String customerCode) {
		this.customerCode = customerCode;
	}

	public String getCustomerName() {
		return this.customerName;
	}

	public void setCustomerName(String customerName) {
		this.customerName = customerName;
	}

	public String getDateOfBirth() {
		return this.dateOfBirth;
	}

	public void setDateOfBirth(String dateOfBirth) {
		this.dateOfBirth = dateOfBirth;
	}

	public String getDistrict() {
		return this.district;
	}

	public void setDistrict(String district) {
		this.district = district;
	}

	public String getEMail() {
		return this.eMail;
	}

	public void setEMail(String eMail) {
		this.eMail = eMail;
	}

	public String getExtNumber() {
		return this.extNumber;
	}

	public void setExtNumber(String extNumber) {
		this.extNumber = extNumber;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getFaxExtens() {
		return this.faxExtens;
	}

	public void setFaxExtens(String faxExtens) {
		this.faxExtens = faxExtens;
	}

	public String getFaxNumber() {
		return this.faxNumber;
	}

	public void setFaxNumber(String faxNumber) {
		this.faxNumber = faxNumber;
	}

	public String getFloor() {
		return this.floor;
	}

	public void setFloor(String floor) {
		this.floor = floor;
	}

	public String getIdNo() {
		return this.idNo;
	}

	public void setIdNo(String idNo) {
		this.idNo = idNo;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getMobile() {
		return this.mobile;
	}

	public void setMobile(String mobile) {
		this.mobile = mobile;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getOfficeAddressText() {
		return this.officeAddressText;
	}

	public void setOfficeAddressText(String officeAddressText) {
		this.officeAddressText = officeAddressText;
	}

	public String getPhoneNumber() {
		return this.phoneNumber;
	}

	public void setPhoneNumber(String phoneNumber) {
		this.phoneNumber = phoneNumber;
	}

	public String getRoomNo() {
		return this.roomNo;
	}

	public void setRoomNo(String roomNo) {
		this.roomNo = roomNo;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getTaxId() {
		return this.taxId;
	}

	public void setTaxId(String taxId) {
		this.taxId = taxId;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

	public String getZipCode() {
		return this.zipCode;
	}

	public void setZipCode(String zipCode) {
		this.zipCode = zipCode;
	}

}